package com.test;

import java.util.Arrays;

/**
 * @author chenkh
 * @time 2020/7/15 0:27
 */
public class Main {
    public static void main(String[] args) {
        String srcString = "#####\n" +
                "CREATE TABLE demo  (\n" +
                "  id varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键ID',\n" +
                "  name varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名',\n" +
                "  key_word varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关键词',\n" +
                "  punch_time datetime(0) NULL DEFAULT NULL COMMENT '打卡时间',\n" +
                "  salary_money decimal(10, 3) NULL DEFAULT NULL COMMENT '工资',\n" +
                "  bonus_money double(10, 2) NULL DEFAULT NULL COMMENT '奖金',\n" +
                "  sex varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别 {男:1,女:2}',\n" +
                "  age int(11) NULL DEFAULT NULL COMMENT '年龄',\n" +
                "  birthday date NULL DEFAULT NULL COMMENT '生日',\n" +
                "  email varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',\n" +
                "  content varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '个人简介',\n" +
                "  create_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',\n" +
                "  create_time datetime(0) NULL DEFAULT NULL COMMENT '创建时间',\n" +
                "  update_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人',\n" +
                "  update_time datetime(0) NULL DEFAULT NULL COMMENT '修改时间',\n" +
                "  sys_org_code varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属部门编码',\n" +
                "  PRIMARY KEY (id) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE demo  (\n" +
                "  id varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键ID',\n" +
                "  name varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名',\n" +
                "  key_word varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关键词',\n" +
                "  punch_time datetime(0) NULL DEFAULT NULL COMMENT '打卡时间',\n" +
                "  salary_money decimal(10, 3) NULL DEFAULT NULL COMMENT '工资',\n" +
                "  bonus_money double(10, 2) NULL DEFAULT NULL COMMENT '奖金',\n" +
                "  sex varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别 {男:1,女:2}',\n" +
                "  age int(11) NULL DEFAULT NULL COMMENT '年龄',\n" +
                "  birthday date NULL DEFAULT NULL COMMENT '生日',\n" +
                "  email varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',\n" +
                "  content varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '个人简介',\n" +
                "  create_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',\n" +
                "  create_time datetime(0) NULL DEFAULT NULL COMMENT '创建时间',\n" +
                "  update_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人',\n" +
                "  update_time datetime(0) NULL DEFAULT NULL COMMENT '修改时间',\n" +
                "  sys_org_code varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属部门编码',\n" +
                "  PRIMARY KEY (id) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE demo_field_def_val_main  (\n" +
                "  id varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,\n" +
                "  code varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '编码',\n" +
                "  name varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '姓名',\n" +
                "  sex varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '性别',\n" +
                "  address varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '地址',\n" +
                "  address_param varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '地址（传参）',\n" +
                "  create_user varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',\n" +
                "  create_time datetime(0) NULL DEFAULT NULL COMMENT '创建日期',\n" +
                "  update_user varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人',\n" +
                "  update_time datetime(0) NULL DEFAULT NULL COMMENT '更新日期',\n" +
                "  sys_org_code varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属部门',\n" +
                "  PRIMARY KEY (id) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE demo_field_def_val_sub  (\n" +
                "  id varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,\n" +
                "  code varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '编码',\n" +
                "  name varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '名称',\n" +
                "  date varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '日期',\n" +
                "  main_id varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '主表ID',\n" +
                "  create_user varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',\n" +
                "  create_time datetime(0) NULL DEFAULT NULL COMMENT '创建日期',\n" +
                "  update_user varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人',\n" +
                "  update_time datetime(0) NULL DEFAULT NULL COMMENT '更新日期',\n" +
                "  sys_org_code varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属部门',\n" +
                "  PRIMARY KEY (id) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE generator_column_config  (\n" +
                "  id varchar(38) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '列配置id',\n" +
                "  column_config_group_id varchar(38) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '配置组id',\n" +
                "  src_name varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '原始字段名称',\n" +
                "  target_name varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '转换字段名称',\n" +
                "  comment varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '注释',\n" +
                "  type varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '字段全类型',\n" +
                "  short_type varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '字段短类型',\n" +
                "  label_name varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标签名',\n" +
                "  form_item_type varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '表单数据类型',\n" +
                "  form_item_source_type varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '表单数据源类型',\n" +
                "  form_item_source varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '表单数据源',\n" +
                "  form_item_rules varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '表单验证规则',\n" +
                "  require varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '必填',\n" +
                "  hidden varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '隐藏',\n" +
                "  vague_config_code varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模糊匹配码',\n" +
                "  ext1 varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '扩展字段1',\n" +
                "  ext2 varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '扩展字段2',\n" +
                "  ext3 varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '扩展字段3',\n" +
                "  ext4 varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '扩展字段4',\n" +
                "  ext5 varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '扩展字段5',\n" +
                "  ext6 varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '扩展字段6',\n" +
                "  ext7 varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '扩展字段7',\n" +
                "  ext8 varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '扩展字段8',\n" +
                "  ext9 varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '扩展字段9',\n" +
                "  ext10 varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '扩展字段10',\n" +
                "  create_user varchar(38) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',\n" +
                "  create_time datetime(0) NULL DEFAULT NULL COMMENT '创建时间',\n" +
                "  update_user varchar(38) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人',\n" +
                "  update_time datetime(0) NULL DEFAULT NULL COMMENT '修改时间',\n" +
                "  effective varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态',\n" +
                "  PRIMARY KEY (id) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE generator_column_config_group  (\n" +
                "  id varchar(38) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '列配置组id',\n" +
                "  name varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '配置名',\n" +
                "  note varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',\n" +
                "  table_name varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '对应表名',\n" +
                "  create_user varchar(38) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',\n" +
                "  create_time datetime(0) NULL DEFAULT NULL COMMENT '创建时间',\n" +
                "  update_user varchar(38) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人',\n" +
                "  update_time datetime(0) NULL DEFAULT NULL COMMENT '修改时间',\n" +
                "  effective varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态',\n" +
                "  PRIMARY KEY (id) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE generator_global_config  (\n" +
                "  id varchar(38) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '全局配置id',\n" +
                "  global_config_group_id varchar(38) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '宏空间id',\n" +
                "  note varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',\n" +
                "  name varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '宏名称',\n" +
                "  value varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '宏值',\n" +
                "  create_user varchar(38) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',\n" +
                "  create_time datetime(0) NULL DEFAULT NULL COMMENT '创建时间',\n" +
                "  update_user varchar(38) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人',\n" +
                "  update_time datetime(0) NULL DEFAULT NULL COMMENT '修改时间',\n" +
                "  effective varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态',\n" +
                "  PRIMARY KEY (id) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE generator_global_config_group  (\n" +
                "  id varchar(38) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '宏空间id',\n" +
                "  name varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '宏空间名称',\n" +
                "  note varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '注释',\n" +
                "  create_user varchar(38) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',\n" +
                "  create_time datetime(0) NULL DEFAULT NULL COMMENT '创建时间',\n" +
                "  update_user varchar(38) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人',\n" +
                "  update_time datetime(0) NULL DEFAULT NULL COMMENT '修改时间',\n" +
                "  effective varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态',\n" +
                "  PRIMARY KEY (id) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE generator_template  (\n" +
                "  id varchar(38) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '模板id',\n" +
                "  template_group_id varchar(38) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模板域id',\n" +
                "  name varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模板域名称',\n" +
                "  code text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '模板代码',\n" +
                "  note varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模板注释',\n" +
                "  create_user varchar(38) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',\n" +
                "  create_time datetime(0) NULL DEFAULT NULL COMMENT '创建时间',\n" +
                "  update_user varchar(38) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人',\n" +
                "  update_time datetime(0) NULL DEFAULT NULL COMMENT '修改时间',\n" +
                "  effective varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态',\n" +
                "  PRIMARY KEY (id) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE generator_template_group  (\n" +
                "  id varchar(38) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '模板域id',\n" +
                "  name varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模板域名称',\n" +
                "  note varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模板域注释',\n" +
                "  create_user varchar(38) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',\n" +
                "  create_time datetime(0) NULL DEFAULT NULL COMMENT '创建时间',\n" +
                "  update_user varchar(38) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人',\n" +
                "  update_time datetime(0) NULL DEFAULT NULL COMMENT '修改时间',\n" +
                "  effective varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '有效性',\n" +
                "  PRIMARY KEY (id) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE generator_type_mapper  (\n" +
                "  id varchar(38) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '类型映射id',\n" +
                "  type_mapper_group_id varchar(38) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类型映射域id',\n" +
                "  note varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类型映射注释',\n" +
                "  column_type varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '列类型',\n" +
                "  java_type varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'java类型',\n" +
                "  create_user varchar(38) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',\n" +
                "  create_time datetime(0) NULL DEFAULT NULL COMMENT '创建时间',\n" +
                "  update_user varchar(38) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人',\n" +
                "  update_time datetime(0) NULL DEFAULT NULL COMMENT '修改时间',\n" +
                "  effective varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态',\n" +
                "  PRIMARY KEY (id) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE generator_type_mapper_group  (\n" +
                "  id varchar(38) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '类型映射域id',\n" +
                "  name varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类型映射域名称',\n" +
                "  note varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类型映射域注释',\n" +
                "  create_user varchar(38) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',\n" +
                "  create_time datetime(0) NULL DEFAULT NULL COMMENT '创建时间',\n" +
                "  update_user varchar(38) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人',\n" +
                "  update_time datetime(0) NULL DEFAULT NULL COMMENT '修改时间',\n" +
                "  effective varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态',\n" +
                "  PRIMARY KEY (id) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE jeecg_monthly_growth_analysis  (\n" +
                "  id int(11) NOT NULL AUTO_INCREMENT,\n" +
                "  year varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,\n" +
                "  month varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '月份',\n" +
                "  main_income decimal(18, 2) NULL DEFAULT 0.00 COMMENT '佣金/主营收入',\n" +
                "  other_income decimal(18, 2) NULL DEFAULT 0.00 COMMENT '其他收入',\n" +
                "  PRIMARY KEY (id) USING BTREE\n" +
                ") ENGINE = InnoDB AUTO_INCREMENT = 25 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE jeecg_order_customer  (\n" +
                "  id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',\n" +
                "  name varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '客户名',\n" +
                "  sex varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别',\n" +
                "  idcard varchar(18) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '身份证号码',\n" +
                "  idcard_pic varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '身份证扫描件',\n" +
                "  telphone varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话1',\n" +
                "  order_id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '外键',\n" +
                "  create_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',\n" +
                "  create_time datetime(0) NULL DEFAULT NULL COMMENT '创建时间',\n" +
                "  update_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人',\n" +
                "  update_time datetime(0) NULL DEFAULT NULL COMMENT '修改时间',\n" +
                "  PRIMARY KEY (id) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE jeecg_order_main  (\n" +
                "  id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',\n" +
                "  order_code varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '订单号',\n" +
                "  ctype varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '订单类型',\n" +
                "  order_date datetime(0) NULL DEFAULT NULL COMMENT '订单日期',\n" +
                "  order_money double(10, 3) NULL DEFAULT NULL COMMENT '订单金额',\n" +
                "  content varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '订单备注',\n" +
                "  create_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',\n" +
                "  create_time datetime(0) NULL DEFAULT NULL COMMENT '创建时间',\n" +
                "  update_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人',\n" +
                "  update_time datetime(0) NULL DEFAULT NULL COMMENT '修改时间',\n" +
                "  PRIMARY KEY (id) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE jeecg_order_ticket  (\n" +
                "  id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',\n" +
                "  ticket_code varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '航班号',\n" +
                "  tickect_date datetime(0) NULL DEFAULT NULL COMMENT '航班时间',\n" +
                "  order_id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '外键',\n" +
                "  create_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',\n" +
                "  create_time datetime(0) NULL DEFAULT NULL COMMENT '创建时间',\n" +
                "  update_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人',\n" +
                "  update_time datetime(0) NULL DEFAULT NULL COMMENT '修改时间',\n" +
                "  PRIMARY KEY (id) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE jeecg_project_nature_income  (\n" +
                "  id int(11) NOT NULL AUTO_INCREMENT,\n" +
                "  nature varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '项目性质',\n" +
                "  insurance_fee decimal(18, 2) NULL DEFAULT 0.00 COMMENT '保险经纪佣金费',\n" +
                "  risk_consulting_fee decimal(18, 2) NULL DEFAULT 0.00 COMMENT '风险咨询费',\n" +
                "  evaluation_fee decimal(18, 2) NULL DEFAULT 0.00 COMMENT '承保公估评估费',\n" +
                "  insurance_evaluation_fee decimal(18, 2) NULL DEFAULT 0.00 COMMENT '保险公估费',\n" +
                "  bidding_consulting_fee decimal(18, 2) NULL DEFAULT 0.00 COMMENT '投标咨询费',\n" +
                "  interol_consulting_fee decimal(18, 2) NULL DEFAULT 0.00 COMMENT '内控咨询费',\n" +
                "  PRIMARY KEY (id) USING BTREE\n" +
                ") ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE joa_demo  (\n" +
                "  id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'ID',\n" +
                "  name varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请假人',\n" +
                "  days int(11) NULL DEFAULT NULL COMMENT '请假天数',\n" +
                "  begin_date datetime(0) NULL DEFAULT NULL COMMENT '开始时间',\n" +
                "  end_date datetime(0) NULL DEFAULT NULL COMMENT '请假结束时间',\n" +
                "  reason varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请假原因',\n" +
                "  bpm_status varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '1' COMMENT '流程状态',\n" +
                "  create_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人id',\n" +
                "  create_time datetime(0) NULL DEFAULT NULL COMMENT '创建时间',\n" +
                "  update_time datetime(0) NULL DEFAULT NULL COMMENT '修改时间',\n" +
                "  update_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人id'\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程测试' ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE oss_file  (\n" +
                "  id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键id',\n" +
                "  file_name varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件名称',\n" +
                "  url varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件地址',\n" +
                "  create_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人登录名称',\n" +
                "  create_time datetime(0) NULL DEFAULT NULL COMMENT '创建日期',\n" +
                "  update_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人登录名称',\n" +
                "  update_time datetime(0) NULL DEFAULT NULL COMMENT '更新日期',\n" +
                "  PRIMARY KEY (id) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'Oss File' ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE qrtz_blob_triggers  (\n" +
                "  sched_name varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  trigger_name varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  trigger_group varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  blob_data blob NULL,\n" +
                "  PRIMARY KEY (sched_name, trigger_name, trigger_group) USING BTREE,\n" +
                "  CONSTRAINT qrtz_blob_triggers_ibfk_1 FOREIGN KEY (sched_name, trigger_name, trigger_group) REFERENCES qrtz_triggers (sched_name, trigger_name, trigger_group) ON DELETE RESTRICT ON UPDATE RESTRICT\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'InnoDB free: 504832 kB; (SCHED_NAME TRIGGER_NAME TRIGGE' ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE qrtz_calendars  (\n" +
                "  sched_name varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  calendar_name varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  calendar blob NOT NULL,\n" +
                "  PRIMARY KEY (sched_name, calendar_name) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE qrtz_cron_triggers  (\n" +
                "  sched_name varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  trigger_name varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  trigger_group varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  cron_expression varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  time_zone_id varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,\n" +
                "  PRIMARY KEY (sched_name, trigger_name, trigger_group) USING BTREE,\n" +
                "  CONSTRAINT qrtz_cron_triggers_ibfk_1 FOREIGN KEY (sched_name, trigger_name, trigger_group) REFERENCES qrtz_triggers (sched_name, trigger_name, trigger_group) ON DELETE RESTRICT ON UPDATE RESTRICT\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'InnoDB free: 504832 kB; (SCHED_NAME TRIGGER_NAME TRIGGE' ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE qrtz_fired_triggers  (\n" +
                "  sched_name varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  entry_id varchar(95) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  trigger_name varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  trigger_group varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  instance_name varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  fired_time bigint(13) NOT NULL,\n" +
                "  sched_time bigint(13) NOT NULL,\n" +
                "  priority int(11) NOT NULL,\n" +
                "  state varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  job_name varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,\n" +
                "  job_group varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,\n" +
                "  is_nonconcurrent varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,\n" +
                "  requests_recovery varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,\n" +
                "  PRIMARY KEY (sched_name, entry_id) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE qrtz_job_details  (\n" +
                "  sched_name varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  job_name varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  job_group varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  description varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,\n" +
                "  job_class_name varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  is_durable varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  is_nonconcurrent varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  is_update_data varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  requests_recovery varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  job_data blob NULL,\n" +
                "  PRIMARY KEY (sched_name, job_name, job_group) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE qrtz_locks  (\n" +
                "  sched_name varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  lock_name varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  PRIMARY KEY (sched_name, lock_name) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE qrtz_paused_trigger_grps  (\n" +
                "  sched_name varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  trigger_group varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  PRIMARY KEY (sched_name, trigger_group) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE qrtz_scheduler_state  (\n" +
                "  sched_name varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  instance_name varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  last_checkin_time bigint(13) NOT NULL,\n" +
                "  checkin_interval bigint(13) NOT NULL,\n" +
                "  PRIMARY KEY (sched_name, instance_name) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE qrtz_simple_triggers  (\n" +
                "  sched_name varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  trigger_name varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  trigger_group varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  repeat_count bigint(7) NOT NULL,\n" +
                "  repeat_interval bigint(12) NOT NULL,\n" +
                "  times_triggered bigint(10) NOT NULL,\n" +
                "  PRIMARY KEY (sched_name, trigger_name, trigger_group) USING BTREE,\n" +
                "  CONSTRAINT qrtz_simple_triggers_ibfk_1 FOREIGN KEY (sched_name, trigger_name, trigger_group) REFERENCES qrtz_triggers (sched_name, trigger_name, trigger_group) ON DELETE RESTRICT ON UPDATE RESTRICT\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'InnoDB free: 504832 kB; (SCHED_NAME TRIGGER_NAME TRIGGE' ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE qrtz_simprop_triggers  (\n" +
                "  sched_name varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  trigger_name varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  trigger_group varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  str_prop_1 varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,\n" +
                "  str_prop_2 varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,\n" +
                "  str_prop_3 varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,\n" +
                "  int_prop_1 int(11) NULL DEFAULT NULL,\n" +
                "  int_prop_2 int(11) NULL DEFAULT NULL,\n" +
                "  long_prop_1 bigint(20) NULL DEFAULT NULL,\n" +
                "  long_prop_2 bigint(20) NULL DEFAULT NULL,\n" +
                "  dec_prop_1 decimal(13, 4) NULL DEFAULT NULL,\n" +
                "  dec_prop_2 decimal(13, 4) NULL DEFAULT NULL,\n" +
                "  bool_prop_1 varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,\n" +
                "  bool_prop_2 varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,\n" +
                "  PRIMARY KEY (sched_name, trigger_name, trigger_group) USING BTREE,\n" +
                "  CONSTRAINT qrtz_simprop_triggers_ibfk_1 FOREIGN KEY (sched_name, trigger_name, trigger_group) REFERENCES qrtz_triggers (sched_name, trigger_name, trigger_group) ON DELETE RESTRICT ON UPDATE RESTRICT\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'InnoDB free: 504832 kB; (SCHED_NAME TRIGGER_NAME TRIGGE' ROW_FORMAT = Compact;\n";
       String tmpSrcString1 = "#####\n" +
                "CREATE TABLE qrtz_triggers  (\n" +
                "  sched_name varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  trigger_name varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  trigger_group varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  job_name varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  job_group varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  description varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,\n" +
                "  next_fire_time bigint(13) NULL DEFAULT NULL,\n" +
                "  prev_fire_time bigint(13) NULL DEFAULT NULL,\n" +
                "  priority int(11) NULL DEFAULT NULL,\n" +
                "  trigger_state varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  trigger_type varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  start_time bigint(13) NOT NULL,\n" +
                "  end_time bigint(13) NULL DEFAULT NULL,\n" +
                "  calendar_name varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,\n" +
                "  misfire_instr smallint(2) NULL DEFAULT NULL,\n" +
                "  job_data blob NULL,\n" +
                "  PRIMARY KEY (sched_name, trigger_name, trigger_group) USING BTREE,\n" +
                "  INDEX sched_name(sched_name, job_name, job_group) USING BTREE,\n" +
                "  CONSTRAINT qrtz_triggers_ibfk_1 FOREIGN KEY (sched_name, job_name, job_group) REFERENCES qrtz_job_details (sched_name, job_name, job_group) ON DELETE RESTRICT ON UPDATE RESTRICT\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'InnoDB free: 504832 kB; (SCHED_NAME JOB_NAME JOB_GROUP' ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE sys_announcement  (\n" +
                "  id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  title varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标题',\n" +
                "  msg_content text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '内容',\n" +
                "  start_time datetime(0) NULL DEFAULT NULL COMMENT '开始时间',\n" +
                "  end_time datetime(0) NULL DEFAULT NULL COMMENT '结束时间',\n" +
                "  sender varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发布人',\n" +
                "  priority varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '优先级（L低，M中，H高）',\n" +
                "  msg_category varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '2' COMMENT '消息类型1:通知公告2:系统消息',\n" +
                "  msg_type varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '通告对象类型（USER:指定用户，ALL:全体用户）',\n" +
                "  send_status varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发布状态（0未发布，1已发布，2已撤销）',\n" +
                "  send_time datetime(0) NULL DEFAULT NULL COMMENT '发布时间',\n" +
                "  cancel_time datetime(0) NULL DEFAULT NULL COMMENT '撤销时间',\n" +
                "  del_flag varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '删除状态（0，正常，1已删除）',\n" +
                "  bus_type varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '业务类型(email:邮件 bpm:流程)',\n" +
                "  bus_id varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '业务id',\n" +
                "  open_type varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '打开方式(组件：component 路由：url)',\n" +
                "  open_page varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '组件/路由 地址',\n" +
                "  create_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',\n" +
                "  create_time datetime(0) NULL DEFAULT NULL COMMENT '创建时间',\n" +
                "  update_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人',\n" +
                "  update_time datetime(0) NULL DEFAULT NULL COMMENT '更新时间',\n" +
                "  user_ids text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '指定用户',\n" +
                "  msg_abstract text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '摘要',\n" +
                "  PRIMARY KEY (id) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统通告表' ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE sys_announcement_send  (\n" +
                "  id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,\n" +
                "  annt_id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '通告ID',\n" +
                "  user_id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户id',\n" +
                "  read_flag varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '阅读状态（0未读，1已读）',\n" +
                "  read_time datetime(0) NULL DEFAULT NULL COMMENT '阅读时间',\n" +
                "  create_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',\n" +
                "  create_time datetime(0) NULL DEFAULT NULL COMMENT '创建时间',\n" +
                "  update_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人',\n" +
                "  update_time datetime(0) NULL DEFAULT NULL COMMENT '更新时间'\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户通告阅读标记表' ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE sys_category  (\n" +
                "  id varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  pid varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '父级节点',\n" +
                "  name varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类型名称',\n" +
                "  code varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类型编码',\n" +
                "  create_user varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',\n" +
                "  create_time datetime(0) NULL DEFAULT NULL COMMENT '创建日期',\n" +
                "  update_user varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人',\n" +
                "  update_time datetime(0) NULL DEFAULT NULL COMMENT '更新日期',\n" +
                "  sys_org_code varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属部门',\n" +
                "  has_child varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否有子节点',\n" +
                "  PRIMARY KEY (id) USING BTREE,\n" +
                "  UNIQUE INDEX index_code(code) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE sys_check_rule  (\n" +
                "  id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键id',\n" +
                "  rule_name varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '规则名称',\n" +
                "  rule_code varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '规则Code',\n" +
                "  rule_json varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '规则JSON',\n" +
                "  rule_description varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '规则描述',\n" +
                "  update_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人',\n" +
                "  update_time datetime(0) NULL DEFAULT NULL COMMENT '更新时间',\n" +
                "  create_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',\n" +
                "  create_time datetime(0) NULL DEFAULT NULL COMMENT '创建时间',\n" +
                "  PRIMARY KEY (id) USING BTREE,\n" +
                "  UNIQUE INDEX uni_sys_check_rule_code(rule_code) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE sys_data_log  (\n" +
                "  id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'id',\n" +
                "  create_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人登录名称',\n" +
                "  create_time datetime(0) NULL DEFAULT NULL COMMENT '创建日期',\n" +
                "  update_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人登录名称',\n" +
                "  update_time datetime(0) NULL DEFAULT NULL COMMENT '更新日期',\n" +
                "  data_table varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '表名',\n" +
                "  data_id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '数据ID',\n" +
                "  data_content text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '数据内容',\n" +
                "  data_version int(11) NULL DEFAULT NULL COMMENT '版本号',\n" +
                "  PRIMARY KEY (id) USING BTREE,\n" +
                "  INDEX sindex(data_table, data_id) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE sys_data_source  (\n" +
                "  id varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,\n" +
                "  code varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '数据源编码',\n" +
                "  name varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '数据源名称',\n" +
                "  remark varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',\n" +
                "  db_type varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '数据库类型',\n" +
                "  db_driver varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '驱动类',\n" +
                "  db_url varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '数据源地址',\n" +
                "  db_name varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '数据库名称',\n" +
                "  db_username varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户名',\n" +
                "  db_password varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '密码',\n" +
                "  create_user varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',\n" +
                "  create_time datetime(0) NULL DEFAULT NULL COMMENT '创建日期',\n" +
                "  update_user varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人',\n" +
                "  update_time datetime(0) NULL DEFAULT NULL COMMENT '更新日期',\n" +
                "  sys_org_code varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属部门',\n" +
                "  PRIMARY KEY (id) USING BTREE,\n" +
                "  UNIQUE INDEX sys_data_source_code_uni(code) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE sys_depart  (\n" +
                "  id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'ID',\n" +
                "  parent_id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '父机构ID',\n" +
                "  depart_name varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '机构/部门名称',\n" +
                "  depart_name_en varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '英文名',\n" +
                "  depart_name_abbr varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '缩写',\n" +
                "  depart_order int(11) NULL DEFAULT 0 COMMENT '排序',\n" +
                "  description varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',\n" +
                "  org_category varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1' COMMENT '机构类别 1组织机构，2岗位',\n" +
                "  org_type varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '机构类型 1一级部门 2子部门',\n" +
                "  org_code varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '机构编码',\n" +
                "  mobile varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机号',\n" +
                "  fax varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '传真',\n" +
                "  address varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址',\n" +
                "  memo varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',\n" +
                "  status varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态（1启用，0不启用）',\n" +
                "  del_flag varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '删除状态（0，正常，1已删除）',\n" +
                "  create_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',\n" +
                "  create_time datetime(0) NULL DEFAULT NULL COMMENT '创建日期',\n" +
                "  update_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人',\n" +
                "  update_time datetime(0) NULL DEFAULT NULL COMMENT '更新日期',\n" +
                "  PRIMARY KEY (id) USING BTREE,\n" +
                "  UNIQUE INDEX uniq_depart_org_code(org_code) USING BTREE,\n" +
                "  INDEX index_depart_parent_id(parent_id) USING BTREE,\n" +
                "  INDEX index_depart_depart_order(depart_order) USING BTREE,\n" +
                "  INDEX index_depart_org_code(org_code) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '组织机构表' ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE sys_depart_permission  (\n" +
                "  id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  depart_id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部门id',\n" +
                "  permission_id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '权限id',\n" +
                "  data_rule_ids varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '数据规则id',\n" +
                "  PRIMARY KEY (id) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '部门权限表' ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE sys_depart_role  (\n" +
                "  id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  depart_id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部门id',\n" +
                "  role_name varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部门角色名称',\n" +
                "  role_code varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部门角色编码',\n" +
                "  description varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',\n" +
                "  create_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',\n" +
                "  create_time datetime(0) NULL DEFAULT NULL COMMENT '创建时间',\n" +
                "  update_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人',\n" +
                "  update_time datetime(0) NULL DEFAULT NULL COMMENT '更新时间',\n" +
                "  PRIMARY KEY (id) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '部门角色表' ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE sys_depart_role_permission  (\n" +
                "  id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  depart_id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部门id',\n" +
                "  role_id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色id',\n" +
                "  permission_id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '权限id',\n" +
                "  data_rule_ids varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,\n" +
                "  PRIMARY KEY (id) USING BTREE,\n" +
                "  INDEX index_group_role_per_id(role_id, permission_id) USING BTREE,\n" +
                "  INDEX index_group_role_id(role_id) USING BTREE,\n" +
                "  INDEX index_group_per_id(permission_id) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '部门角色权限表' ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE sys_depart_role_user  (\n" +
                "  id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键id',\n" +
                "  user_id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户id',\n" +
                "  drole_id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色id',\n" +
                "  PRIMARY KEY (id) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '部门角色用户表' ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE sys_dict  (\n" +
                "  id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  dict_name varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '字典名称',\n" +
                "  dict_code varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '字典编码',\n" +
                "  description varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',\n" +
                "  del_flag int(1) NULL DEFAULT NULL COMMENT '删除状态',\n" +
                "  create_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',\n" +
                "  create_time datetime(0) NULL DEFAULT NULL COMMENT '创建时间',\n" +
                "  update_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人',\n" +
                "  update_time datetime(0) NULL DEFAULT NULL COMMENT '更新时间',\n" +
                "  type int(1) UNSIGNED ZEROFILL NULL DEFAULT 0 COMMENT '字典类型0为string,1为number',\n" +
                "  PRIMARY KEY (id) USING BTREE,\n" +
                "  UNIQUE INDEX indextable_dict_code(dict_code) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE sys_dict_item  (\n" +
                "  id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  dict_id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '字典id',\n" +
                "  item_text varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '字典项文本',\n" +
                "  item_value varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '字典项值',\n" +
                "  description varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',\n" +
                "  sort_order int(10) NULL DEFAULT NULL COMMENT '排序',\n" +
                "  status int(11) NULL DEFAULT NULL COMMENT '状态（1启用 0不启用）',\n" +
                "  create_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,\n" +
                "  create_time datetime(0) NULL DEFAULT NULL,\n" +
                "  update_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,\n" +
                "  update_time datetime(0) NULL DEFAULT NULL,\n" +
                "  PRIMARY KEY (id) USING BTREE,\n" +
                "  INDEX index_table_dict_id(dict_id) USING BTREE,\n" +
                "  INDEX index_table_sort_order(sort_order) USING BTREE,\n" +
                "  INDEX index_table_dict_status(status) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE sys_fill_rule  (\n" +
                "  id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键ID',\n" +
                "  rule_name varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '规则名称',\n" +
                "  rule_code varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '规则Code',\n" +
                "  rule_class varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '规则实现类',\n" +
                "  rule_params varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '规则参数',\n" +
                "  update_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人',\n" +
                "  update_time datetime(0) NULL DEFAULT NULL COMMENT '修改时间',\n" +
                "  create_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',\n" +
                "  create_time datetime(0) NULL DEFAULT NULL COMMENT '创建时间',\n" +
                "  PRIMARY KEY (id) USING BTREE,\n" +
                "  UNIQUE INDEX uni_sys_fill_rule_code(rule_code) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE sys_log  (\n" +
                "  id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  log_type int(2) NULL DEFAULT NULL COMMENT '日志类型（1登录日志，2操作日志）',\n" +
                "  log_content varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '日志内容',\n" +
                "  operate_type int(2) NULL DEFAULT NULL COMMENT '操作类型',\n" +
                "  userid varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作用户账号',\n" +
                "  username varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作用户名称',\n" +
                "  ip varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'IP',\n" +
                "  method varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请求java方法',\n" +
                "  request_url varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请求路径',\n" +
                "  request_param longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '请求参数',\n" +
                "  request_type varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请求类型',\n" +
                "  cost_time bigint(20) NULL DEFAULT NULL COMMENT '耗时',\n" +
                "  create_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',\n" +
                "  create_time datetime(0) NULL DEFAULT NULL COMMENT '创建时间',\n" +
                "  update_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人',\n" +
                "  update_time datetime(0) NULL DEFAULT NULL COMMENT '更新时间',\n" +
                "  PRIMARY KEY (id) USING BTREE,\n" +
                "  INDEX index_table_userid(userid) USING BTREE,\n" +
                "  INDEX index_logt_ype(log_type) USING BTREE,\n" +
                "  INDEX index_operate_type(operate_type) USING BTREE,\n" +
                "  INDEX index_log_type(log_type) USING BTREE\n" +
                ") ENGINE = MyISAM CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统日志表' ROW_FORMAT = Dynamic;\n" +
                "#####\n" +
                "CREATE TABLE sys_permission  (\n" +
                "  id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键id',\n" +
                "  parent_id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '父id',\n" +
                "  name varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单标题',\n" +
                "  url varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '路径',\n" +
                "  component varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '组件',\n" +
                "  component_name varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '组件名字',\n" +
                "  redirect varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '一级菜单跳转地址',\n" +
                "  menu_type int(11) NULL DEFAULT NULL COMMENT '菜单类型(0:一级菜单; 1:子菜单:2:按钮权限)',\n" +
                "  perms varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单权限编码',\n" +
                "  perms_type varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '权限策略1显示2禁用',\n" +
                "  sort_no double(8, 2) NULL DEFAULT NULL COMMENT '菜单排序',\n" +
                "  always_show tinyint(1) NULL DEFAULT NULL COMMENT '聚合子路由: 1是0否',\n" +
                "  icon varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单图标',\n" +
                "  is_route tinyint(1) NULL DEFAULT 1 COMMENT '是否路由菜单: 0:不是  1:是（默认值1）',\n" +
                "  is_leaf tinyint(1) NULL DEFAULT NULL COMMENT '是否叶子节点:    1:是   0:不是',\n" +
                "  keep_alive tinyint(1) NULL DEFAULT NULL COMMENT '是否缓存该页面:    1:是   0:不是',\n" +
                "  hidden int(2) NULL DEFAULT 0 COMMENT '是否隐藏路由: 0否,1是',\n" +
                "  description varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',\n" +
                "  create_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',\n" +
                "  create_time datetime(0) NULL DEFAULT NULL COMMENT '创建时间',\n" +
                "  update_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人',\n" +
                "  update_time datetime(0) NULL DEFAULT NULL COMMENT '更新时间',\n" +
                "  del_flag int(1) NULL DEFAULT 0 COMMENT '删除状态 0正常 1已删除',\n" +
                "  rule_flag int(3) NULL DEFAULT 0 COMMENT '是否添加数据权限1是0否',\n" +
                "  status varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '按钮权限状态(0无效1有效)',\n" +
                "  internal_or_external tinyint(1) NULL DEFAULT NULL COMMENT '外链菜单打开方式 0/内部打开 1/外部打开',\n" +
                "  PRIMARY KEY (id) USING BTREE,\n" +
                "  INDEX index_prem_pid(parent_id) USING BTREE,\n" +
                "  INDEX index_prem_is_route(is_route) USING BTREE,\n" +
                "  INDEX index_prem_is_leaf(is_leaf) USING BTREE,\n" +
                "  INDEX index_prem_sort_no(sort_no) USING BTREE,\n" +
                "  INDEX index_prem_del_flag(del_flag) USING BTREE,\n" +
                "  INDEX index_menu_type(menu_type) USING BTREE,\n" +
                "  INDEX index_menu_hidden(hidden) USING BTREE,\n" +
                "  INDEX index_menu_status(status) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '菜单权限表' ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE sys_permission_data_rule  (\n" +
                "  id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'ID',\n" +
                "  permission_id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单ID',\n" +
                "  rule_name varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '规则名称',\n" +
                "  rule_column varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '字段',\n" +
                "  rule_conditions varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '条件',\n" +
                "  rule_value varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '规则值',\n" +
                "  status varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '权限有效状态1有0否',\n" +
                "  create_time datetime(0) NULL DEFAULT NULL COMMENT '创建时间',\n" +
                "  create_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,\n" +
                "  update_time datetime(0) NULL DEFAULT NULL COMMENT '修改时间',\n" +
                "  update_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人',\n" +
                "  PRIMARY KEY (id) USING BTREE,\n" +
                "  INDEX index_fucntionid(permission_id) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE sys_position  (\n" +
                "  id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  code varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '职务编码',\n" +
                "  name varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '职务名称',\n" +
                "  post_rank varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '职级',\n" +
                "  company_id varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '公司id',\n" +
                "  create_user varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',\n" +
                "  create_time datetime(0) NULL DEFAULT NULL COMMENT '创建时间',\n" +
                "  update_user varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人',\n" +
                "  update_time datetime(0) NULL DEFAULT NULL COMMENT '修改时间',\n" +
                "  sys_org_code varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '组织机构编码',\n" +
                "  PRIMARY KEY (id) USING BTREE,\n" +
                "  UNIQUE INDEX uniq_code(code) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE sys_quartz_job  (\n" +
                "  id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  create_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',\n" +
                "  create_time datetime(0) NULL DEFAULT NULL COMMENT '创建时间',\n" +
                "  del_flag int(1) NULL DEFAULT NULL COMMENT '删除状态',\n" +
                "  update_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人',\n" +
                "  update_time datetime(0) NULL DEFAULT NULL COMMENT '修改时间',\n" +
                "  job_class_name varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '任务类名',\n" +
                "  cron_expression varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'cron表达式',\n" +
                "  parameter varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '参数',\n" +
                "  description varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',\n" +
                "  status int(1) NULL DEFAULT NULL COMMENT '状态 0正常 -1停止',\n" +
                "  PRIMARY KEY (id) USING BTREE,\n" +
                "  UNIQUE INDEX uniq_job_class_name(job_class_name) USING BTREE\n" +
                ") ENGINE = MyISAM CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;\n" +
                "#####\n" +
                "CREATE TABLE sys_role  (\n" +
                "  id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键id',\n" +
                "  role_name varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色名称',\n" +
                "  role_code varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色编码',\n" +
                "  description varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',\n" +
                "  create_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',\n" +
                "  create_time datetime(0) NULL DEFAULT NULL COMMENT '创建时间',\n" +
                "  update_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人',\n" +
                "  update_time datetime(0) NULL DEFAULT NULL COMMENT '更新时间',\n" +
                "  PRIMARY KEY (id) USING BTREE,\n" +
                "  UNIQUE INDEX uniq_sys_role_role_code(role_code) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色表' ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE sys_role_permission  (\n" +
                "  id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  role_id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色id',\n" +
                "  permission_id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '权限id',\n" +
                "  data_rule_ids varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,\n" +
                "  PRIMARY KEY (id) USING BTREE,\n" +
                "  INDEX index_group_role_per_id(role_id, permission_id) USING BTREE,\n" +
                "  INDEX index_group_role_id(role_id) USING BTREE,\n" +
                "  INDEX index_group_per_id(permission_id) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色权限表' ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE sys_sms  (\n" +
                "  id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'ID',\n" +
                "  es_title varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '消息标题',\n" +
                "  es_type varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发送方式：1短信 2邮件 3微信',\n" +
                "  es_receiver varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '接收人',\n" +
                "  es_param varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发送所需参数Json格式',\n" +
                "  es_content longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '推送内容',\n" +
                "  es_send_time datetime(0) NULL DEFAULT NULL COMMENT '推送时间',\n" +
                "  es_send_status varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '推送状态 0未推送 1推送成功 2推送失败 -1失败不再发送',\n" +
                "  es_send_num int(11) NULL DEFAULT NULL COMMENT '发送次数 超过5次不再发送',\n" +
                "  es_result varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '推送失败原因',\n" +
                "  remark varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',\n" +
                "  create_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人登录名称',\n" +
                "  create_time datetime(0) NULL DEFAULT NULL COMMENT '创建日期',\n" +
                "  update_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人登录名称',\n" +
                "  update_time datetime(0) NULL DEFAULT NULL COMMENT '更新日期',\n" +
                "  PRIMARY KEY (id) USING BTREE,\n" +
                "  INDEX index_type(es_type) USING BTREE,\n" +
                "  INDEX index_receiver(es_receiver) USING BTREE,\n" +
                "  INDEX index_sendtime(es_send_time) USING BTREE,\n" +
                "  INDEX index_status(es_send_status) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE sys_sms_template  (\n" +
                "  id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',\n" +
                "  template_name varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模板标题',\n" +
                "  template_code varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '模板CODE',\n" +
                "  template_type varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '模板类型：1短信 2邮件 3微信',\n" +
                "  template_content varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '模板内容',\n" +
                "  template_test_json varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模板测试json',\n" +
                "  create_time datetime(0) NULL DEFAULT NULL COMMENT '创建日期',\n" +
                "  create_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人登录名称',\n" +
                "  update_time datetime(0) NULL DEFAULT NULL COMMENT '更新日期',\n" +
                "  update_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人登录名称',\n" +
                "  PRIMARY KEY (id) USING BTREE,\n" +
                "  UNIQUE INDEX uniq_templatecode(template_code) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE sys_user  (\n" +
                "  id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键id',\n" +
                "  username varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录账号',\n" +
                "  realname varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '真实姓名',\n" +
                "  password varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',\n" +
                "  salt varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'md5密码盐',\n" +
                "  avatar varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '头像',\n" +
                "  birthday datetime(0) NULL DEFAULT NULL COMMENT '生日',\n" +
                "  sex tinyint(1) NULL DEFAULT NULL COMMENT '性别(0-默认未知,1-男,2-女)',\n" +
                "  email varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电子邮件',\n" +
                "  phone varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话',\n" +
                "  org_code varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '机构编码',\n" +
                "  status tinyint(1) NULL DEFAULT NULL COMMENT '性别(1-正常,2-冻结)',\n" +
                "  del_flag tinyint(1) NULL DEFAULT NULL COMMENT '删除状态(0-正常,1-已删除)',\n" +
                "  third_id varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '第三方登录的唯一标识',\n" +
                "  third_type varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '第三方类型',\n" +
                "  activiti_sync tinyint(1) NULL DEFAULT NULL COMMENT '同步工作流引擎(1-同步,0-不同步)',\n" +
                "  work_no varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '工号，唯一键',\n" +
                "  post varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '职务，关联职务表',\n" +
                "  telephone varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '座机号',\n" +
                "  create_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',\n" +
                "  create_time datetime(0) NULL DEFAULT NULL COMMENT '创建时间',\n" +
                "  update_user varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人',\n" +
                "  update_time datetime(0) NULL DEFAULT NULL COMMENT '更新时间',\n" +
                "  user_identity tinyint(1) NULL DEFAULT NULL COMMENT '身份（1普通成员 2上级）',\n" +
                "  depart_ids longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '负责部门',\n" +
                "  PRIMARY KEY (id) USING BTREE,\n" +
                "  UNIQUE INDEX index_user_name(username) USING BTREE,\n" +
                "  UNIQUE INDEX uniq_sys_user_work_no(work_no) USING BTREE,\n" +
                "  UNIQUE INDEX uniq_sys_user_username(username) USING BTREE,\n" +
                "  UNIQUE INDEX uniq_sys_user_phone(phone) USING BTREE,\n" +
                "  UNIQUE INDEX uniq_sys_user_email(email) USING BTREE,\n" +
                "  INDEX index_user_status(status) USING BTREE,\n" +
                "  INDEX index_user_del_flag(del_flag) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户表' ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE sys_user_agent  (\n" +
                "  id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '序号',\n" +
                "  user_name varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名',\n" +
                "  agent_user_name varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '代理人用户名',\n" +
                "  start_time datetime(0) NULL DEFAULT NULL COMMENT '代理开始时间',\n" +
                "  end_time datetime(0) NULL DEFAULT NULL COMMENT '代理结束时间',\n" +
                "  status varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态0无效1有效',\n" +
                "  create_name varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人名称',\n" +
                "  create_user varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人登录名称',\n" +
                "  create_time datetime(0) NULL DEFAULT NULL COMMENT '创建日期',\n" +
                "  update_name varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人名称',\n" +
                "  update_user varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人登录名称',\n" +
                "  update_time datetime(0) NULL DEFAULT NULL COMMENT '更新日期',\n" +
                "  sys_org_code varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属部门',\n" +
                "  sys_company_code varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属公司',\n" +
                "  PRIMARY KEY (id) USING BTREE,\n" +
                "  UNIQUE INDEX uniq_username(user_name) USING BTREE,\n" +
                "  INDEX statux_index(status) USING BTREE,\n" +
                "  INDEX begintime_index(start_time) USING BTREE,\n" +
                "  INDEX endtime_index(end_time) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户代理人设置' ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE sys_user_depart  (\n" +
                "  id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'id',\n" +
                "  user_id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户id',\n" +
                "  dep_id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部门id',\n" +
                "  PRIMARY KEY (id) USING BTREE,\n" +
                "  INDEX index_depart_groupk_userid(user_id) USING BTREE,\n" +
                "  INDEX index_depart_groupkorgid(dep_id) USING BTREE,\n" +
                "  INDEX index_depart_groupk_uidanddid(user_id, dep_id) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE sys_user_role  (\n" +
                "  id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键id',\n" +
                "  user_id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户id',\n" +
                "  role_id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色id',\n" +
                "  PRIMARY KEY (id) USING BTREE,\n" +
                "  INDEX index2_groupuu_user_id(user_id) USING BTREE,\n" +
                "  INDEX index2_groupuu_ole_id(role_id) USING BTREE,\n" +
                "  INDEX index2_groupuu_useridandroleid(user_id, role_id) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户角色表' ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE test_demo  (\n" +
                "  id varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',\n" +
                "  create_user varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人登录名称',\n" +
                "  create_time datetime(0) NULL DEFAULT NULL COMMENT '创建日期',\n" +
                "  update_user varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人登录名称',\n" +
                "  update_time datetime(0) NULL DEFAULT NULL COMMENT '更新日期',\n" +
                "  name varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名',\n" +
                "  sex varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别',\n" +
                "  age int(32) NULL DEFAULT NULL COMMENT '年龄',\n" +
                "  descc varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',\n" +
                "  birthday datetime(0) NULL DEFAULT NULL COMMENT '生日',\n" +
                "  user_code varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户编码',\n" +
                "  file_kk varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '附件',\n" +
                "  top_pic varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '头像',\n" +
                "  PRIMARY KEY (id) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE test_enhance_select  (\n" +
                "  id varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,\n" +
                "  province varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '省份',\n" +
                "  city varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '市',\n" +
                "  area varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '区',\n" +
                "  create_time datetime(0) NULL DEFAULT NULL COMMENT '创建日期',\n" +
                "  create_user varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',\n" +
                "  PRIMARY KEY (id) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE test_order_main  (\n" +
                "  id varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  create_user varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',\n" +
                "  create_time datetime(0) NULL DEFAULT NULL COMMENT '创建日期',\n" +
                "  update_user varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人',\n" +
                "  update_time datetime(0) NULL DEFAULT NULL COMMENT '更新日期',\n" +
                "  order_code varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '订单编码',\n" +
                "  order_date datetime(0) NULL DEFAULT NULL COMMENT '下单时间',\n" +
                "  descc varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',\n" +
                "  PRIMARY KEY (id) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE test_order_product  (\n" +
                "  id varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',\n" +
                "  create_user varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',\n" +
                "  create_time datetime(0) NULL DEFAULT NULL COMMENT '创建日期',\n" +
                "  update_user varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人',\n" +
                "  update_time datetime(0) NULL DEFAULT NULL COMMENT '更新日期',\n" +
                "  product_name varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '产品名字',\n" +
                "  price double(32, 0) NULL DEFAULT NULL COMMENT '价格',\n" +
                "  num int(32) NULL DEFAULT NULL COMMENT '数量',\n" +
                "  descc varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',\n" +
                "  order_fk_id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单外键ID',\n" +
                "  pro_type varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '产品类型',\n" +
                "  PRIMARY KEY (id) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE test_person  (\n" +
                "  id varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n" +
                "  create_user varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',\n" +
                "  create_time datetime(0) NULL DEFAULT NULL COMMENT '创建日期',\n" +
                "  update_user varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人',\n" +
                "  update_time datetime(0) NULL DEFAULT NULL COMMENT '更新日期',\n" +
                "  sex varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别',\n" +
                "  name varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名',\n" +
                "  content longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '请假原因',\n" +
                "  be_date datetime(0) NULL DEFAULT NULL COMMENT '请假时间',\n" +
                "  qj_days int(11) NULL DEFAULT NULL COMMENT '请假天数',\n" +
                "  PRIMARY KEY (id) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;\n" +
                "#####\n" +
                "CREATE TABLE test_shoptype_tree  (\n" +
                "  id varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键',\n" +
                "  create_user varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',\n" +
                "  create_time datetime(0) NULL DEFAULT NULL COMMENT '创建日期',\n" +
                "  update_user varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人',\n" +
                "  update_time datetime(0) NULL DEFAULT NULL COMMENT '更新日期',\n" +
                "  sys_org_code varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属部门',\n" +
                "  type_name varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '商品分类',\n" +
                "  pic varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '分类图片',\n" +
                "  pid varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '父级节点',\n" +
                "  has_child varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否有子节点',\n" +
                "  PRIMARY KEY (id) USING BTREE\n" +
                ") ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;\n" +
                "\n" +
                "SET FOREIGN_KEY_CHECKS = 1;\n";


      Arrays.asList(srcString.split("#####")).stream().forEach(s->{
           process(s);
       });


        Arrays.asList(tmpSrcString1.split("#####")).stream().forEach(s->{
            System.out.println(s);
        });

    }

    public static String process(String s){
        StringBuilder stringBuilder = new StringBuilder();
        StringBuilder commentBuilder = new StringBuilder();
        Arrays.asList(s.split("\n")).stream().forEach(line->{
            if (!"".equals(line)){
                if(line.contains("id")){
                    line = "\"id\" varchar(38) COLLATE \"pg_catalog\".\"default\" NOT NULL,";
                }
                stringBuilder.append("\n").append(line);
                //todo：完善
            }
        });
        return stringBuilder.toString();
    }
}
